prompt ********************************************
prompt Creating sequences - BEGIN
prompt ********************************************

WHENEVER SQLERROR EXIT SQL.SQLCODE

--------------------------------------------------------
--  Create Triggers --
--------------------------------------------------------

CREATE SEQUENCE "MR_ADMIN"."SEQ_FILES_ID"  INCREMENT BY 1  START WITH 1  NOMAXVALUE  MINVALUE 1  NOCYCLE  NOCACHE  NOORDER;
--CREATE OR REPLACE TRIGGER "MR_ADMIN"."TRG_FILES_ID"  BEFORE INSERT  ON FILES  FOR EACH ROW  BEGIN  SELECT SEQ_FILES_ID.NEXTVAL  INTO :NEW.ID  FROM DUAL; 
CREATE SEQUENCE "MR_ADMIN"."SEQ_ISSUE_ID"  INCREMENT BY 1  START WITH 1  NOMAXVALUE  MINVALUE 1  NOCYCLE  NOCACHE  NOORDER;
--CREATE OR REPLACE TRIGGER "MR_ADMIN"."TRG_ISSUE_ID"  BEFORE INSERT  ON ISSUE  FOR EACH ROW  BEGIN  SELECT SEQ_ISSUE_ID.NEXTVAL  INTO :NEW.ID  FROM DUAL;
CREATE SEQUENCE "MR_ADMIN"."SEQ_PROJECT_ID"  INCREMENT BY 1  START WITH 1  NOMAXVALUE  MINVALUE 1  NOCYCLE  NOCACHE  NOORDER;
--CREATE OR REPLACE TRIGGER "MR_ADMIN"."TRG_PROJECT_ID"  BEFORE INSERT  ON PROJECT  FOR EACH ROW  BEGIN  SELECT SEQ_PROJECT_ID.NEXTVAL  INTO :NEW.ID  FROM DUAL; 
CREATE SEQUENCE "MR_ADMIN"."SEQ_USERS_ID"  INCREMENT BY 1  START WITH 1  NOMAXVALUE  MINVALUE 1  NOCYCLE  NOCACHE  NOORDER;
--CREATE OR REPLACE TRIGGER "MR_ADMIN"."TRG_USERS_ID"  BEFORE INSERT  ON USERS  FOR EACH ROW  BEGIN  SELECT SEQ_USERS_ID.NEXTVAL  INTO :NEW.ID  FROM DUAL; 
CREATE SEQUENCE "MR_ADMIN"."SEQ_CO_ROLE_ID"  INCREMENT BY 1  START WITH 1  NOMAXVALUE  MINVALUE 1  NOCYCLE  NOCACHE  NOORDER;
--CREATE OR REPLACE TRIGGER "MR_ADMIN"."TRG_CO_ROLE_ID"  BEFORE INSERT  ON CO_ROLE  FOR EACH ROW  BEGIN  SELECT SEQ_CO_ROLE_ID.NEXTVAL  INTO :NEW.ID  FROM DUAL;
   

prompt **********************************************************
prompt Creating sequences - END
prompt **********************************************************